package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.Dept;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface DeptMapper extends BaseMapper<Dept> {
//    @Select("select  * from dept")
//    public List<Dept> findAll ();
//
//    @Delete("delete from dept where id = #{id}")
//    void deleteById ( Integer id );
//
//    @Insert("insert into dept(name,create_time,update_time) values(#{name},#{createTime},#{updateTime})")
//    void add ( Dept dept );
//
//    @Select("select * from dept where  id = #{id}")
//    Dept getById ( Integer deptId );
//
//    @Update("update dept set name = #{name},update_time = #{updateTime} where id = #{id}")
//    void update ( Dept dept );
//
    @Select("select count(*) from emp where dept_id = #{deptId}")
    int countEmpsInDept ( Integer deptId );
}